
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Class Home represents the home page of the website.
/// </summary>
public partial class Home : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        DataView dvSqlHome = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
        foreach (DataRowView drvSqlHome in dvSqlHome)
        {
            Label1.Text = drvSqlHome["Title"].ToString();
            Image12.ImageUrl = "http://62991199.com/Uploads/News/" + drvSqlHome["Thumb_Photo"].ToString();
            Image12.Width = 222;
            Image12.Height = 222;
            HyperLink1.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvSqlHome["ID"].ToString();
        }
        
        DataRowView drvHome0 = dvSqlHome[0];
        DataRowView drvHome1 = dvSqlHome[1];
        DataRowView drvHome2 = dvSqlHome[2];
        DataRowView drvHome3 = dvSqlHome[3];
        DataRowView drvHome4 = dvSqlHome[4];
        Label2.Text = drvHome0["Title"].ToString();
        Label3.Text = drvHome1["Title"].ToString();
        Label4.Text = drvHome2["Title"].ToString();
        Label5.Text = drvHome3["Title"].ToString();
        Label6.Text = drvHome4["Title"].ToString();
        HyperLink1.NavigateUrl = "AndrologyDetail.aspx?idNewsContents="+drvHome0["ID"].ToString();
        HyperLink2.NavigateUrl = "AndrologyDetail.aspx?idNewsContents="+drvHome0["ID"].ToString();
        HyperLink3.NavigateUrl = "AndrologyDetail.aspx?idNewsContents="+drvHome1["ID"].ToString();
        HyperLink4.NavigateUrl = "AndrologyDetail.aspx?idNewsContents="+drvHome2["ID"].ToString();
        HyperLink5.NavigateUrl = "AndrologyDetail.aspx?idNewsContents="+drvHome3["ID"].ToString();
        HyperLink6.NavigateUrl = "AndrologyDetail.aspx?idNewsContents="+drvHome4["ID"].ToString();
        /*HyperLink2.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvHome0["ID"].ToString();
        HyperLink3.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvHome1["ID"].ToString();
        HyperLink4.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvHome2["ID"].ToString();
        HyperLink5.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvHome3["ID"].ToString();
        HyperLink6.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvHome4["ID"].ToString();*/

        DataView dvSqlAndrology = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
        foreach (DataRowView drvSqlAndrology in dvSqlAndrology)
        {
            Label7.Text = drvSqlAndrology["Title"].ToString();
            Image1.ImageUrl = "http://62991199.com/Uploads/News/" + drvSqlAndrology["Thumb_Photo"].ToString();
            Image1.Width = 222;
            Image1.Height = 222;
            HyperLink7.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvSqlAndrology["ID"].ToString();
        }
        DataRowView drvSqlAndrology0 = dvSqlAndrology[0];
        DataRowView drvSqlAndrology1 = dvSqlAndrology[1];
        DataRowView drvSqlAndrology2 = dvSqlAndrology[2];
        DataRowView drvSqlAndrology3 = dvSqlAndrology[3];
        DataRowView drvSqlAndrology4 = dvSqlAndrology[4];
        Label8.Text = drvSqlAndrology0["Title"].ToString();
        Label9.Text = drvSqlAndrology1["Title"].ToString();
        Label10.Text = drvSqlAndrology2["Title"].ToString();
        Label11.Text = drvSqlAndrology3["Title"].ToString();
        Label12.Text = drvSqlAndrology4["Title"].ToString();
        HyperLink8.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvSqlAndrology0["ID"].ToString();
        HyperLink9.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvSqlAndrology1["ID"].ToString();
        HyperLink10.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvSqlAndrology2["ID"].ToString();
        HyperLink11.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvSqlAndrology3["ID"].ToString();
        HyperLink12.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvSqlAndrology4["ID"].ToString();

        DataView dvSqlGynaecology = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty);
        foreach (DataRowView drvSqlGynaecology in dvSqlGynaecology)
        {
            Label13.Text = drvSqlGynaecology["Title"].ToString();
            Image2.ImageUrl = "http://62991199.com/Uploads/News/" + drvSqlGynaecology["Thumb_Photo"].ToString();
            Image2.Width = 222;
            Image2.Height = 222;
            HyperLink13.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvSqlGynaecology["ID"].ToString();
        }
        DataRowView drvSqlGynaecology0 = dvSqlGynaecology[0];
        DataRowView drvSqlGynaecology1 = dvSqlGynaecology[1];
        DataRowView drvSqlGynaecology2 = dvSqlGynaecology[2];
        DataRowView drvSqlGynaecology3 = dvSqlGynaecology[3];
        DataRowView drvSqlGynaecology4 = dvSqlGynaecology[4];
        Label14.Text = drvSqlGynaecology0["Title"].ToString();
        Label15.Text = drvSqlGynaecology1["Title"].ToString();
        Label16.Text = drvSqlGynaecology2["Title"].ToString();
        Label17.Text = drvSqlGynaecology3["Title"].ToString();
        Label18.Text = drvSqlGynaecology4["Title"].ToString();
        HyperLink14.NavigateUrl = "GynaecologyDetail.aspx?idNewsContents=" + drvSqlGynaecology0["ID"].ToString();
        HyperLink15.NavigateUrl = "GynaecologyDetail.aspx?idNewsContents=" + drvSqlGynaecology1["ID"].ToString();
        HyperLink16.NavigateUrl = "GynaecologyDetail.aspx?idNewsContents=" + drvSqlGynaecology2["ID"].ToString();
        HyperLink17.NavigateUrl = "GynaecologyDetail.aspx?idNewsContents=" + drvSqlGynaecology3["ID"].ToString();
        HyperLink18.NavigateUrl = "GynaecologyDetail.aspx?idNewsContents=" + drvSqlGynaecology4["ID"].ToString();

        DataView dvSqlInfertility = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty);
        foreach (DataRowView drvSqlInfertility in dvSqlInfertility)
        {
            Label19.Text = drvSqlInfertility["Title"].ToString();
            Image3.ImageUrl = "http://62991199.com/Uploads/News/" + drvSqlInfertility["Thumb_Photo"].ToString();
            Image3.Width = 222;
            Image3.Height = 222;
            HyperLink19.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvSqlInfertility["ID"].ToString();
        }
        DataRowView drvSqlInfertility0 = dvSqlInfertility[0];
        DataRowView drvSqlInfertility1 = dvSqlInfertility[1];
        DataRowView drvSqlInfertility2 = dvSqlInfertility[2];
        DataRowView drvSqlInfertility3 = dvSqlInfertility[3];
        DataRowView drvSqlInfertility4 = dvSqlInfertility[4];
        Label20.Text = drvSqlInfertility0["Title"].ToString();
        Label21.Text = drvSqlInfertility1["Title"].ToString();
        Label22.Text = drvSqlInfertility2["Title"].ToString();
        Label23.Text = drvSqlInfertility3["Title"].ToString();
        Label24.Text = drvSqlInfertility4["Title"].ToString();
        HyperLink20.NavigateUrl = "InfertilityDetail.aspx?idNewsContents=" + drvSqlInfertility0["ID"].ToString();
        HyperLink21.NavigateUrl = "InfertilityDetail.aspx?idNewsContents=" + drvSqlInfertility1["ID"].ToString();
        HyperLink22.NavigateUrl = "InfertilityDetail.aspx?idNewsContents=" + drvSqlInfertility2["ID"].ToString();
        HyperLink23.NavigateUrl = "InfertilityDetail.aspx?idNewsContents=" + drvSqlInfertility3["ID"].ToString();
        HyperLink24.NavigateUrl = "InfertilityDetail.aspx?idNewsContents=" + drvSqlInfertility4["ID"].ToString();

        DataView dvSqlSTDs = (DataView)SqlDataSource5.Select(DataSourceSelectArguments.Empty);
        foreach (DataRowView drvSqlSTDs in dvSqlSTDs)
        {
            Label25.Text = drvSqlSTDs["Title"].ToString();
            Image4.ImageUrl = "http://62991199.com/Uploads/News/" + drvSqlSTDs["Thumb_Photo"].ToString();
            Image4.Width = 222;
            Image4.Height = 222;
            HyperLink25.NavigateUrl = "AndrologyDetail.aspx?idNewsContents=" + drvSqlSTDs["ID"].ToString();
        }
        DataRowView drvSqlSTDs0 = dvSqlSTDs[0];
        DataRowView drvSqlSTDs1 = dvSqlSTDs[1];
        DataRowView drvSqlSTDs2 = dvSqlSTDs[2];
        DataRowView drvSqlSTDs3 = dvSqlSTDs[3];
        DataRowView drvSqlSTDs4 = dvSqlSTDs[4];
        Label26.Text = drvSqlSTDs0["Title"].ToString();
        Label27.Text = drvSqlSTDs1["Title"].ToString();
        Label28.Text = drvSqlSTDs2["Title"].ToString();
        Label29.Text = drvSqlSTDs3["Title"].ToString();
        Label30.Text = drvSqlSTDs4["Title"].ToString();
        HyperLink26.NavigateUrl = "STDsDetail.aspx?idNewsContents=" + drvSqlSTDs0["ID"].ToString();
        HyperLink27.NavigateUrl = "STDsDetail.aspx?idNewsContents=" + drvSqlSTDs1["ID"].ToString();
        HyperLink28.NavigateUrl = "STDsDetail.aspx?idNewsContents=" + drvSqlSTDs2["ID"].ToString();
        HyperLink29.NavigateUrl = "STDsDetail.aspx?idNewsContents=" + drvSqlSTDs3["ID"].ToString();
        HyperLink30.NavigateUrl = "STDsDetail.aspx?idNewsContents=" + drvSqlSTDs4["ID"].ToString();
    }

}
